SyServiceExceptionAudit 
Logical Entity Name  SyServiceExceptionAudit 
Default Table Name  SyServiceExceptionAudit 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SyServiceExceptionAudit Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyServiceExceptionAuditId(PK)    int  NO 
 
ExceptionHashId    numeric(20, 0)  NO 
 
SyServiceExceptionActionId(FK)    int  NO 
 
PreviousExceptionStatusId(FK)    int  YES 
 
CurrentExceptionStatusId(FK)    int  NO 
 
PreviousAssignedStaffId(FK)    int  YES 
 
CurrentAssignedStaffId(FK)    int  YES 
 
PreviousAssignedStaffGroupId(FK)    int  YES 
 
CurrentAssignedStaffGroupId(FK)    int  YES 
 
PreviousReviewStaffId(FK)    int  YES 
 
CurrentReviewStaffId(FK)    int  YES 
 
CurrentReviewStaffGroupId(FK)    int  YES 
 
PreviousReviewStaffGroupId(FK)    int  YES 
 
PreviousLockedById(FK)    int  YES 
 
CurrentLockedById(FK)    int  YES 
 
PreviousLockedOn    datetime  YES 
 
CurrentLockedOn    datetime  YES 
 
Comment    nvarchar(max)  NO 
 
PreviousDataValues    xml  NO 
 
CurrentDataValues    xml  NO 
 
SnoozeUntil    datetime  YES 
 
ExpiresOn    datetime  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
PreviousIsEscalated    bit  NO 
 
CurrentIsEscalated    bit  NO 
 

SyServiceExceptionAudit Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_SyServiceExceptionAudit_SyServiceExceptionAuditId  PrimaryKey  SyServiceExceptionAuditId 

SyServiceExceptionAudit Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyStaffGroup  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_CurrentAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId      CurrentAssignedStaffGroupId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_CurrentAssignedStaffId_SyStaff_SyStaffId      CurrentAssignedStaffId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_CurrentLockedById_SyStaff_SyStaffId      CurrentLockedById  NO  YES 
SyStaffGroup  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_CurrentReviewStaffGroupId_SyStaffGroup_SyStaffGroupId      CurrentReviewStaffGroupId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_CurrentReviewStaffId_SyStaff_SyStaffId      CurrentReviewStaffId  NO  YES 
SyStaffGroup  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_PreviousAssignedStaffGroupId_SyStaffGroup_SyStaffGroupId      PreviousAssignedStaffGroupId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_PreviousAssignedStaffId_SyStaff_SyStaffId      PreviousAssignedStaffId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_PreviousLockedById_SyStaff_SyStaffId      PreviousLockedById  NO  YES 
SyStaffGroup  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_PreviousReviewStaffGroupId_SyStaffGroup_SyStaffGroupId      PreviousReviewStaffGroupId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_PreviousReviewStaffId_SyStaff_SyStaffId      PreviousReviewStaffId  NO  YES 
SyServiceExceptionAction  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_ServiceExceptionAction_SyServiceExceptionActionId      SyServiceExceptionActionId  NO  YES 
SyServiceExceptionStatus  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_SyServiceExceptionStatus_CurrentExceptionStatusId      CurrentExceptionStatusId  NO  YES 
SyServiceExceptionStatus  Non-Identifying  Zero or One to Zero or More  FK_SyServiceExceptionAudit_SyServiceExceptionStatus_PreviousExceptionStatusId      PreviousExceptionStatusId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_SyServiceExceptionAudit_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

SyServiceExceptionAudit Check Constraints 
Check Constraint Name  CheckConstraint 

SyServiceExceptionAudit Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group  PRIMARY 

SyServiceExceptionAudit Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.FaaProcessExceptionDataChange 
NO       
Physical (Microsoft SQL Server)
dbo.SyServiceExceptionAudit 
NO       

SyServiceExceptionAudit Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Service 

SyServiceExceptionAudit Data Movement Rules 
Name  Type  Rule Text/Value